import pandas as pd
dict = {'姓名': ['赵文', '李蒙', '刘武', '何花'],
        '职务': ['主管', '副主管', '员工', '员工'],
        '基本工资': [8000, 7000, 5000, 5500],
        '联系方式': ['15202369852', '15023695820', '13621358962', '13102659860']}
index = ['1', '2', '3', '4']
df = pd.DataFrame(dict, index)
df.loc['5'] = ['李华','员工',5200,13652367496]
df.insert(1,'性别',['女','男','男','女','女'])
df.iat[2,2]='副主管'
# a = df[df['职务']=='主管']|[df['职务']=='副主管']
print('所有员工信息：\n', df)
print(df[(df['职务']=='主管')|(df['职务']=='副主管')])
df.to_csv('employee.csv', encoding='GBK')
